IF NOT EXISTS(SELECT name FROM sysobjects  WHERE name = 'SubsidyGoodsMapping')
BEGIN 
CREATE TABLE [dbo].[SubsidyGoodsMapping](
	[GoodsCode] [VARCHAR](15) NOT NULL,
	[SubsidyGoodsCode] [VARCHAR](15) not NULL,
	[SubsidyName] [NVARCHAR](200) NULL,
	[weight] [MONEY] NULL,
	[CreatedBy] [SMALLINT] NULL,
	[CreatedOn] [DATETIME] NULL,
 CONSTRAINT [PK_SubsidyGoodsMapping] PRIMARY KEY CLUSTERED 
(
	[GoodsCode] ASC
)  ON [PRIMARY]
) ON [PRIMARY] 


ALTER TABLE [dbo].[SubsidyGoodsMapping] ADD  DEFAULT (GETDATE()) FOR [CreatedOn]
end